Tabela PerfTreatmentStandard

Definicja tabeli PerfTreatmentStandard

Name

PerfTreatmentStandard

Code

PerfTreatmentStandard

Comment

podpiecie grupy epizodów do standardu leczenia


Lista kolumn tabeli PerfTreatmentStandard

Name

Code

PerfTreatmentStandardID

PerfTreatmentStandardID

TreatmentStandardID

TreatmentStandardID

DiagnosticEpisodeID

DiagnosticEpisodeID

StartDT

StartDT

StopDT

StopDT

Active

Active


Kolumna PerfTreatmentStandardID tabeli PerfTreatmentStandard

Definicja kolumny PerfTreatmentStandardID tabeli PerfTreatmentStandard

Name

PerfTreatmentStandardID

Code

PerfTreatmentStandardID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna TreatmentStandardID tabeli PerfTreatmentStandard

Definicja kolumny TreatmentStandardID tabeli PerfTreatmentStandard

Name

TreatmentStandardID

Code

TreatmentStandardID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

FK TreatmentStandard.TreatmentStandardID


Kolumna DiagnosticEpisodeID tabeli PerfTreatmentStandard

Definicja kolumny DiagnosticEpisodeID tabeli PerfTreatmentStandard

Name

DiagnosticEpisodeID

Code

DiagnosticEpisodeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

FK DiagnosticEpisode.DiagnosticEpisodeID


Kolumna StartDT tabeli PerfTreatmentStandard

Definicja kolumny StartDT tabeli PerfTreatmentStandard

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

Yes

Comment

 


Kolumna StopDT tabeli PerfTreatmentStandard

Definicja kolumny StopDT tabeli PerfTreatmentStandard

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Active tabeli PerfTreatmentStandard

Definicja kolumny Active tabeli PerfTreatmentStandard

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

No

Comment

 


Lista kluczy tabeli PerfTreatmentStandard

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PerfTreatmentStandard

Definicja klucza Identifier_1 tabeli PerfTreatmentStandard

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment